create or replace view vac_application_computations as
with ac as
(
  select
    application_id,
    to_char(computation_sequence) computation_sequence,
    computation_item,
    to_char(computation_point) computation_point,
    computation_type,
    computation,
    authorization_scheme,
    to_char(authorization_scheme_id) authorization_scheme_id,
    build_option,
    condition_type,
    condition_expression1,
    condition_expression2,
    error_message,
    'APEX_APPLICATION_COMPUTATIONS' src_view_name,
    component_comment
--    component_signature
  from APEX_APPLICATION_COMPUTATIONS c
)
select
 application_id,
 authorization_scheme_id,
 computation_item,
 src_view_name,
 U_NAME,
 U_VALUE
from ac
UNPIVOT INCLUDE NULLS
 ( u_value
   FOR    u_name
   IN
   (
    computation_sequence,
    computation_point,
    computation_type,
    computation,
    authorization_scheme,
    build_option,
    condition_type,
    condition_expression1,
    condition_expression2,
    error_message,
    component_comment
--    component_signature
   )
 );

